


INSERT INTO INVENTORY_BALANCE( ID,    REGION_CODE,    WAREHOUSE_CODE,    STOCK_ITEM_NUMBER,    ON_HAND_QUANTITY,    MORTGAGED_QUANTITY,    SAFE_QUANTITY,    UNSALABLE_QUANTITY,    STATUS_,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP) select INVENTORY_BALANCE_ID_SEQ.nextval,    '360' as REGION_CODE,    'UTC1' as WAREHOUSE_CODE,    12345 as STOCK_ITEM_NUMBER,    100 as ON_HAND_QUANTITY,    5 as MORTGAGED_QUANTITY,    0 as SAFE_QUANTITY,    0 as UNSALABLE_QUANTITY,    0 as STATUS_,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO INVENTORY_BALANCE( ID,    REGION_CODE,    WAREHOUSE_CODE,    STOCK_ITEM_NUMBER,    ON_HAND_QUANTITY,    MORTGAGED_QUANTITY,    SAFE_QUANTITY,    UNSALABLE_QUANTITY,    STATUS_,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP) select INVENTORY_BALANCE_ID_SEQ.nextval,    '360' as REGION_CODE,    'UTC1' as WAREHOUSE_CODE,    23456 as STOCK_ITEM_NUMBER,    200 as ON_HAND_QUANTITY,  100 as MORTGAGED_QUANTITY,    0 as SAFE_QUANTITY,    0 as UNSALABLE_QUANTITY,    0 as STATUS_,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;


INSERT INTO INVENTORY_TRANSACTION(    ID,    REF_ID,    REF_SOURCE,    WAREHOUSE_CODE,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE,    ON_HAND_QUANTITY,    MORTGAGED_QUANTITY,    UNSALABLE_QUANTITY,    TRANSACTION_CODE,    STATUS_,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    INVENTORY_TRANSACTION_ID_SEQ.nextval,    0 as REF_ID,    null as REF_SOURCE,    'UTC1' as WAREHOUSE_CODE,    12345 as STOCK_ITEM_NUMBER,    20110905000000  as TRANSACTION_DATE,    0 as ON_HAND_QUANTITY,    5 as MORTGAGED_QUANTITY,    0 as UNSALABLE_QUANTITY,    'M' as TRANSACTION_CODE,    0 as STATUS_,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;
INSERT INTO INVENTORY_TRANSACTION(    ID,    REF_ID,    REF_SOURCE,    WAREHOUSE_CODE,    STOCK_ITEM_NUMBER,    TRANSACTION_DATE,    ON_HAND_QUANTITY,    MORTGAGED_QUANTITY,    UNSALABLE_QUANTITY,    TRANSACTION_CODE,    STATUS_,    CREATED_TIMESTAMP,    MODIFIED_TIMESTAMP)select    INVENTORY_TRANSACTION_ID_SEQ.nextval,    0 as REF_ID,    null as REF_SOURCE,    'UTC1' as WAREHOUSE_CODE,    23456 as STOCK_ITEM_NUMBER,    20111005000000  as TRANSACTION_DATE,    0 as ON_HAND_QUANTITY,    6 as MORTGAGED_QUANTITY,    0 as UNSALABLE_QUANTITY,    'M' as TRANSACTION_CODE,    0 as STATUS_,    current_timestamp as CREATED_TIMESTAMP,    current_timestamp as MODIFIED_TIMESTAMP from dual;